﻿CREATE TABLE [dbo].[AW_SaleTransactionCollection] (
    [TransactionId]       UNIQUEIDENTIFIER NOT NULL,
    [CollectAmt]          DECIMAL (18, 2)  NULL,
    [CollectCompleteBy]   UNIQUEIDENTIFIER NULL,
    [CollectCompleteDate] DATETIME         NULL,
    [ID]                  INT              IDENTITY (1, 1) NOT NULL,
    [Remark]              NVARCHAR (MAX)   NULL,
    [CollectionType]      NVARCHAR (30)    DEFAULT ('Vendor') NULL,
    CONSTRAINT [PK__AW_SaleTransacti__18EBB532] PRIMARY KEY CLUSTERED ([ID] ASC)
);



